<?php
$id = $_POST["id"];
$status = $_POST['status'];
$card_sta = $_POST['card_sta'];
$beizhu = $_POST['beizhu'];
$oderid = $_POST['oderid'];

include_once("../../untils/conn.php");

if ($con) {
    mysqli_query($con, "set names utf8");
    $data = $con->query("UPDATE oder SET status ='" . $status . "',card_sta ='" . $card_sta . "', beizhu='" . $beizhu . "'where id=" . $id);
   
    if ($data > 0) {
        echo "<script>alert('修改信息成功');window.location.href='../oderlist.php'</script> ";
    } else {
        // echo "Error updating record: " . $con->error;
        echo "<script>alert('修改信息失败');window.location.href='../oderlist.php'</script> ";
    }
}

$sql = "UPDATE revenue SET oder_sta = '$status' WHERE oderid = '$oderid'";
if ($con->query($sql) === TRUE) {
//   echo "Record updated successfully";
} else {
//   echo "Error updating record: " . $con->error;
}

$con->close();
?>
